2014-05-29 - 8009.200 - Spec - POS Integration #ABAPREPORTS #OpenOrders

SPECIFICATIONS

8009.200 -Spec- POS Integration


Purpose

Modify the ZIMM_XML_INVENTORY_OUTPUT to allow for use in feeding master material data to Retail Pro for EMEA Retail Pro implementation

Admin Info

Purpose
 Modify the ZIMM_XML_INVENTORY_OUTPUT to allow for use in feeding master material data to Retail Pro for EMEA Retail Pro implementation
Requested By
 Craig Spangler
Spec Created By
 Deepak Yasam
Spec Created Date
 05/29/2014
Spec QA by
 Deepak yasam
Objects
 ZIMM_XML_INVENTORY_OUTPUT
Document Status
 WIP


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 08
2
 Documentation
 08
3
 Development/ Config
 20 + 6
4
 Unit test in DEV
 10 + 3
5
 Unit test in QUA
 10
6
 Other activity

TOTAL
 56 + 9

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

None


Documents

[Attach any document(s) received for the requirement(s)]

Retail Pro Inventory Updates EMEA.docxInventoryGB.xmlInventoryEUR.xml


Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any
1
 The change in ZMRP value should trigger the material in the file.The ZMRP value from A552 table should be considered but not from the SO.
 Craig Spangler
 06/25/2014
 NA
2
 Move color text from Description 2 to Description 3 and leave Description 2 field blank that needs to used in Retail Pro
 Craig Spangler
 07/25/2014
 NA
3
 Tax codes should be switched on the extract; if tax code on the MM is 1 or 0, the output should be 0 or 1 respectively
 Craig Spangler
 08/12/2014
 NA
4
 Tax code should always appear as 1 (Taxable) in the extract if the currency in the selection in EUR with Date as the selected option
 Craig Spangler
 08/13/2014
 NA
5
 The Tax code should dispaly as 1(tax exempt) and 0(fully taxable) if the tax values are 0 and 1 respectively in MM for GBP . The tax value should always be 0 in the file for EUR currency irrespective of tax values in MM.
 Craig Spangler
 08/20/2014
 N/A
6
 Logic is enhanced to improve the performance of A552 table in fecthing the ZMRP price change condition records.
 Craig Spangler
 09/15/2014
 N/A





Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

Modify the ZIMM_XML_INVENTORY_OUTPUT to allow for use in feeding master material data to Retail Pro for EMEA Retail Pro implementation

In Scope:

[List the activities to be included in scope]
Only the list of changes that are listed in the spec document have been changed in the program.

Out of Scope:

[Out of scope activities]
The changes that are not mentioned in the spec document will remain as existing.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

The program ZIMM_XML_INVENTORY_OUTPUT needs to be modified with certain changes as mentioned in the spec document by NE.Below are the new changes that needs to be done.

1.Currency_nameshould reflect GBP or EUR

2. udf2_value should be PH level 1

3. DCS Code
Department – Product Hierarchy Level 1
Class – Product Hierarchy Level 2
Sub Class – Product Hierarchy Level 3
Must be a full 8 characters, spaces can divide PH levels
dcs_code="01 26 M "

4.UDF field changes

5.Pricing
INVN_SBS_PRICE price_lvl="1" price="34.99" Should reflect MSRP
INVN_SBS_PRICE price_lvl="2" price="0.00" No need to populate

6. GBP will be sbs_no 1 and EUR will be sbs_no 2

6. The ZMRP value should be considered from the A552 table but not from the SO.While considering the value the latest price record should be dispalyed.

7.The change in ZMRP should trigger the material in the output.

Test Plan

[List test scenarios/cases to be executed here]
Test ID
 Test Scenario
 Expected Results
SD001
 Execute the program with single material and without reatil orders check box ,with 2000 sales org and GBP in the selection screen.
 All the above fields should be updated with the new values and ZMRP value should be printed from the A552 table as specified for the given specific material .
SD002
 Execute the program with single material and without reatil orders check box ,with 2000 sales org and EUR in the selection screen.
 All the above fields should be updated with the new values and ZMRP value should be printed from the A552 table as specified for the given specific material .
SD003
 Execute the program with single material and with reatil orders check box ,with 2000 sales org and GBP in the selection screen.
 All the above fields should be updated with the new values and ZMRP value should be printed from the first SO as specified for the given specific material .
SD004
 Execute the program with single material and with reatil orders check box ,with 2000 sales org and EUR in the selection screen.
 All the above fields should be updated with the new values and ZMRP value should be printed from the first SO specified for the given specific material .
SD005
 Execute the program with reatil orders check box ,with 2000 sales org and GBP in the selection screen as inputs.
 All the above fields should be updated with the new values as specified for all the materials which has retail attribute check in product attributes.ZMRP value should be printed from the first SO if SO exsits or from A552 table in the absence of SO's
SD006
 Execute the program with reatil orders check box ,with 2000 sales org and EUR in the selection screen as inputs.
 All the above fields should be updated with the new values as specified for all the materials which has retail attribute check in product attributes.
ZMRP value should be printed from the first SO if SO exsits or from A552 table in the absence of SO's

Solution Details

[Provide complete technical details for configuration or programming here]



Issues

[List Issues / Bugs identified in configuration or development]